-- =============================================
-- Author:		KhanhPQ1
-- Create date: 09//04/2014
-- Description:	get all pages by language
-- =============================================
CREATE PROCEDURE [dbo].[GetAllPagesByLanguageId]
@LanguageId int
AS
BEGIN
	SET NOCOUNT ON;
	SELECT [PageId]
		  ,[PageName]
		  ,[Action]
		  ,[Controller]
		  ,[PageFamilyId]
		  ,[LanguageId]
		  ,[UserId]
		  ,[CreatedDate]
	FROM Pages
	WHERE LanguageId = @LanguageId
END
